<?php
/**
 * Cookie操作関数<br />
 *
 * @package apamanshop
 * @author　
 * @copyright　
 */
class Cmsapi_Model_Mypage extends Apm_Model_Base
{

	/**
	* マイページユーザ情報取得
	*/
	public function getUserInfo($eMail)
	{
		$db_params = array();

		$sql = $this->getUserInfoSql($eMail, &$db_params);
		$data = $this->dbGetData($sql, $db_params);

		return $data;
	}

	/**
	* マイページユーザ情報取得SQL
	*/
	public function getUserInfoSql($eMail, &$db_params)
	{
		$db_params["strUserId"] = $eMail;

		$sql .= "SELECT";
		$sql .= "        M92_USER_CD";
		$sql .= "        ,M92_HANDLE_NAME";
		$sql .= "    FROM";
		$sql .= "        M92MYPAGE_USER";
		$sql .= "    WHERE";
		$sql .= "        M92_E_MAIL = :strUserId ";
		$sql .= "        AND M92_DELETE_FLG = 0";

		return $sql;
	}
}
?>